package com.bjtu.transactionclient.api.constant;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class SQLContant {

    /**插入*/
    public static final String INSERT = "INSERT";
    /**更新*/
    public static final String UPDATE = "UPDATE";
    /**删除*/
    public static final String DELETE = "DELETE";

    /**包含IndexNo字段的表*/
    public static List<String> TableName_IndexNoMap = init();

    /**不包含IndexNo字段的表*/
    public static List<String> TableName_No_IndexNoMap = init2();

    private static List<String> init() {
        List<String> tmpList = new ArrayList<>();
        tmpList.add("booktable1");
        tmpList.add("booktable2");
        tmpList.add("deletedindexnotable");
        tmpList.add("journalpaperstable1");
        tmpList.add("journalpaperstable2");
        tmpList.add("journaltable1");
        tmpList.add("journaltable2");
        tmpList.add("proceedingspapertable1");
        tmpList.add("proceedingspapertable2");
        tmpList.add("proceedingstable1");
        tmpList.add("proceedingstable2");
        tmpList.add("reporttable1");
        tmpList.add("reporttable2");
        tmpList.add("subsetindexnotable");
        tmpList.add("thesistable1");
        tmpList.add("thesistable2");
        tmpList.add("userindexnotable");
        return tmpList;
    }

    private static List<String> init2() {
        List<String> tmpList = new ArrayList<>();
        tmpList.add("citystatetable");
        tmpList.add("institutiontable1");
        tmpList.add("institutiontable2");
        tmpList.add("publishertable1");
        tmpList.add("publishertable2");
        tmpList.add("roles");
        tmpList.add("teamtable");
        tmpList.add("usertable");
        tmpList.add("userupdateofverisonandtables");
        return tmpList;
    }
}
